package kr.or.kosta.otr.persistence.companyreview;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;

import kr.or.kosta.otr.vo.CompanyReviewVO;
import kr.or.kosta.otr.vo.CompanyVO;

public interface CompanyReviewDao {
	int writeCompanyReview(CompanyReviewVO vo)throws SQLException;
	void deleteCompanyReview(int company_review_id)throws SQLException;
	void deleteCompanyReviewByUser(HashMap<String, Object> map)throws SQLException;
	CompanyReviewVO getOneCompanyReviewById(int companyReviewId)throws SQLException;
	ArrayList<CompanyReviewVO> getAllCompanyReview()throws SQLException;
	CompanyReviewVO getCompanyReviewByScoreId(int scoreId)throws SQLException;
	ArrayList<CompanyReviewVO> getAllCompanyReviewByUserId(String userId) throws SQLException;
	CompanyReviewVO getRecentCompanyReview()throws SQLException;
	ArrayList<CompanyReviewVO> getCompanyReviewByCompanyName(String companyName) throws SQLException;
	//main
	int getTopSalaryCompanyId() throws SQLException;
	int getHotCompanyId() throws SQLException;
	int getRecentReviewedCompanyId() throws SQLException;
}